SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for xf_ainmodule_fortune
-- ----------------------------
DROP TABLE IF EXISTS `xf_ainmodule_fortune`;
CREATE TABLE `xf_ainmodule_fortune` (
  `id` int NOT NULL AUTO_INCREMENT,
  `text` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL,
  `width` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of xf_ainmodule_fortune
-- ----------------------------
BEGIN;
INSERT INTO `xf_ainmodule_fortune` (`id`, `text`, `width`) VALUES (1, '运势', '100');
INSERT INTO `xf_ainmodule_fortune` (`id`, `text`, `width`) VALUES (2, '爱情', '100');
INSERT INTO `xf_ainmodule_fortune` (`id`, `text`, `width`) VALUES (3, '健康', '100');
INSERT INTO `xf_ainmodule_fortune` (`id`, `text`, `width`) VALUES (4, '财富', '100');
COMMIT;

-- ----------------------------
-- Table structure for xf_ainmodule_rest
-- ----------------------------
DROP TABLE IF EXISTS `xf_ainmodule_rest`;
CREATE TABLE `xf_ainmodule_rest` (
  `id` int NOT NULL AUTO_INCREMENT,
  `text` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL,
  `img` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of xf_ainmodule_rest
-- ----------------------------
BEGIN;
INSERT INTO `xf_ainmodule_rest` (`id`, `text`, `img`) VALUES (1, '09:00 起床', '/assets/upload/get_up.png');
INSERT INTO `xf_ainmodule_rest` (`id`, `text`, `img`) VALUES (2, '14:00 上课', '/assets/upload/study.png');
INSERT INTO `xf_ainmodule_rest` (`id`, `text`, `img`) VALUES (3, '23:00 睡觉', '/assets/upload/sleep.png');
COMMIT;

-- ----------------------------
-- Table structure for xf_code
-- ----------------------------
DROP TABLE IF EXISTS `xf_code`;
CREATE TABLE `xf_code` (
  `id` int NOT NULL AUTO_INCREMENT,
  `headCode` text COLLATE utf8mb4_unicode_ci,
  `cssCode` text COLLATE utf8mb4_unicode_ci,
  `footerCode` text COLLATE utf8mb4_unicode_ci,
  `jsCode` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of xf_code
-- ----------------------------
BEGIN;
INSERT INTO `xf_code` (`id`, `headCode`, `cssCode`, `footerCode`, `jsCode`) VALUES (1, NULL, '* { padding: 0; margin: 0; }', '<!-- 解开下面的代码注释即可实现对应的效果 -->\n\n<!-- 1. 点击特效 -->\n<script src=\"/assets/plugIn/fireworks/index.js\"></script>\n\n<!-- 2. 音乐播放器代码【这边调用的是本地资源, 具体的参数需要去https://musicplayer.xfyun.club配置】 -->\n<!-- <div id=\"xf-MusicPlayer\" data-filePath=\"/assets/plugIn/xf-MusicPlayer-master/\"  data-songChart=\"新歌榜\"data-fadeOutAutoplay data-memory=\"1\"></div>\n<script src=\"/assets/plugIn/xf-MusicPlayer-master/xf-MusicPlayer/js/xf-MusicPlayer.min.js\"></script> -->\n\n<!-- 3. 樱花特效 -->\n<!-- <script src=\"/assets/plugIn/sakura/index.js\"></script> -->', '// alert(\'欢迎来到小枫拟态UI5.0Pro\')');
COMMIT;

-- ----------------------------
-- Table structure for xf_config
-- ----------------------------
DROP TABLE IF EXISTS `xf_config`;
CREATE TABLE `xf_config` (
  `id` int NOT NULL AUTO_INCREMENT,
  `siteFields` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '网站字段',
  `xf_values` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`,`siteFields`),
  UNIQUE KEY `id_UNIQUE` (`id`),
  UNIQUE KEY `siteFields_UNIQUE` (`siteFields`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of xf_config
-- ----------------------------
BEGIN;
INSERT INTO `xf_config` (`id`, `siteFields`, `xf_values`) VALUES (1, 'title', '小枫拟态UI5.0Pro - 个人主页');
INSERT INTO `xf_config` (`id`, `siteFields`, `xf_values`) VALUES (2, 'keywords', '拟态ui设计,拟态ui,个人引导页,个人主页,个人介绍页,拟态引导页,简约个人主页,个人主页源码');
INSERT INTO `xf_config` (`id`, `siteFields`, `xf_values`) VALUES (4, 'description', '拟态UI设计是小枫原创的一款简约平滑开源的个人主页设计。');
INSERT INTO `xf_config` (`id`, `siteFields`, `xf_values`) VALUES (5, 'author', '小枫');
INSERT INTO `xf_config` (`id`, `siteFields`, `xf_values`) VALUES (6, 'icon', '/favicon.ico');
INSERT INTO `xf_config` (`id`, `siteFields`, `xf_values`) VALUES (7, 'logo', 'https://cdn.xfabe.com/xfwl/logo.svg');
INSERT INTO `xf_config` (`id`, `siteFields`, `xf_values`) VALUES (8, 'isOn', '1');
INSERT INTO `xf_config` (`id`, `siteFields`, `xf_values`) VALUES (9, 'domain', '');
INSERT INTO `xf_config` (`id`, `siteFields`, `xf_values`) VALUES (10, 'username', '叶晓枫');
INSERT INTO `xf_config` (`id`, `siteFields`, `xf_values`) VALUES (11, 'userAvatarUrl', '/assets/images/xf.jpg');
INSERT INTO `xf_config` (`id`, `siteFields`, `xf_values`) VALUES (12, 'profile', '我热爱你所热爱的一切!|欢迎使用小枫拟态UI5x');
INSERT INTO `xf_config` (`id`, `siteFields`, `xf_values`) VALUES (13, 'days', '2025-03-14');
INSERT INTO `xf_config` (`id`, `siteFields`, `xf_values`) VALUES (14, 'icp', '赣ICP备2020011714号');
INSERT INTO `xf_config` (`id`, `siteFields`, `xf_values`) VALUES (15, 'publicSecurity', '赣公网安备36082502000055号');
INSERT INTO `xf_config` (`id`, `siteFields`, `xf_values`) VALUES (16, 'randomText', '舔狗日记');
INSERT INTO `xf_config` (`id`, `siteFields`, `xf_values`) VALUES (17, 'homeBtnName', 'MY FRIENDS >');
INSERT INTO `xf_config` (`id`, `siteFields`, `xf_values`) VALUES (18, 'friendsBtnName', 'MY HOME >');
INSERT INTO `xf_config` (`id`, `siteFields`, `xf_values`) VALUES (19, 'km', '');
INSERT INTO `xf_config` (`id`, `siteFields`, `xf_values`) VALUES (20, 'key', '');
INSERT INTO `xf_config` (`id`, `siteFields`, `xf_values`) VALUES (21, 'qq', '');
INSERT INTO `xf_config` (`id`, `siteFields`, `xf_values`) VALUES (22, 'isLoad', '1');
INSERT INTO `xf_config` (`id`, `siteFields`, `xf_values`) VALUES (23, 'topBg', '/assets/images/dream.webp');
INSERT INTO `xf_config` (`id`, `siteFields`, `xf_values`) VALUES (24, 'captchaId', '');
INSERT INTO `xf_config` (`id`, `siteFields`, `xf_values`) VALUES (25, 'captchaKey', '');
INSERT INTO `xf_config` (`id`, `siteFields`, `xf_values`) VALUES (26, 'adminKey', '');
INSERT INTO `xf_config` (`id`, `siteFields`, `xf_values`) VALUES (27, 'repeatKey', '');
INSERT INTO `xf_config` (`id`, `siteFields`, `xf_values`) VALUES (28, 'access_restriction', '{\"expirationTime\":\"60\",\"accessTime\":\"60\",\"numberOfVisits\":\"100\",\"shield\":\"180\"}');
INSERT INTO `xf_config` (`id`, `siteFields`, `xf_values`) VALUES (29, 'syncIPTime', '60');
INSERT INTO `xf_config` (`id`, `siteFields`, `xf_values`) VALUES (30, 'thematicPattern', 'auto');
COMMIT;

-- ----------------------------
-- Table structure for xf_ip
-- ----------------------------
DROP TABLE IF EXISTS `xf_ip`;
CREATE TABLE `xf_ip` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ip` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '访问ip',
  `ua` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户设备',
  `pv` int NOT NULL,
  `accessTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '访问时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of xf_ip
-- ----------------------------
BEGIN;
INSERT INTO `xf_ip` (`id`, `ip`, `ua`, `pv`, `accessTime`) VALUES (1, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, '2025-04-22 22:16:44');
COMMIT;

-- ----------------------------
-- Table structure for xf_module
-- ----------------------------
DROP TABLE IF EXISTS `xf_module`;
CREATE TABLE `xf_module` (
  `id` int NOT NULL AUTO_INCREMENT,
  `module` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL,
  `xf_values` varchar(2048) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`,`module`),
  UNIQUE KEY `id_UNIQUE` (`id`),
  UNIQUE KEY `module_UNIQUE` (`module`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of xf_module
-- ----------------------------
BEGIN;
INSERT INTO `xf_module` (`id`, `module`, `xf_values`) VALUES (1, 'ain_rest_title', '作息时间');
INSERT INTO `xf_module` (`id`, `module`, `xf_values`) VALUES (2, 'ain_fortune_title', '今日运势');
INSERT INTO `xf_module` (`id`, `module`, `xf_values`) VALUES (3, 'ain_fortune_stars', '⭐️');
INSERT INTO `xf_module` (`id`, `module`, `xf_values`) VALUES (4, 'ain_fortune_stars_num', '5');
INSERT INTO `xf_module` (`id`, `module`, `xf_values`) VALUES (5, 'ain_information_title', '简介');
INSERT INTO `xf_module` (`id`, `module`, `xf_values`) VALUES (6, 'ain_information_img', '/assets/images/information.png');
INSERT INTO `xf_module` (`id`, `module`, `xf_values`) VALUES (7, 'ain_information_introduced', '欢迎使用小枫拟态UI5.0x个人引导页授权版！');
INSERT INTO `xf_module` (`id`, `module`, `xf_values`) VALUES (8, 'site_title', '旗下站点');
INSERT INTO `xf_module` (`id`, `module`, `xf_values`) VALUES (9, 'site_icon', '/assets/images/site.png');
INSERT INTO `xf_module` (`id`, `module`, `xf_values`) VALUES (10, 'friends_maxLength', '60');
INSERT INTO `xf_module` (`id`, `module`, `xf_values`) VALUES (11, 'limitAddFriendForm', '5');
INSERT INTO `xf_module` (`id`, `module`, `xf_values`) VALUES (12, 'site_list_sort', '1');
INSERT INTO `xf_module` (`id`, `module`, `xf_values`) VALUES (13, 'sponsor_title', '赞助作者');
INSERT INTO `xf_module` (`id`, `module`, `xf_values`) VALUES (14, 'sponsor_desc', '您好，我是拟态5Pro的开发者小枫。很高兴在这里遇到你，如果你对拟态5Pro感兴趣，或者觉得这个项目能够帮到你，我非常愿意与你分享更多关于它的细节和背后的故事。同时，我也期待能够听到你的宝贵意见和建议，共同推动这个项目的不断发展和完善。');
INSERT INTO `xf_module` (`id`, `module`, `xf_values`) VALUES (15, 'sponsor_list_title', '赞助名单');
INSERT INTO `xf_module` (`id`, `module`, `xf_values`) VALUES (16, 'sponsor_btn_text', '请作者吃根热狗🌭');
INSERT INTO `xf_module` (`id`, `module`, `xf_values`) VALUES (17, 'sponsor_list_icon', '/assets/images/zanzhu_list.svg');
INSERT INTO `xf_module` (`id`, `module`, `xf_values`) VALUES (18, 'sponsor_home_icon', '/assets/images/love.svg');
INSERT INTO `xf_module` (`id`, `module`, `xf_values`) VALUES (19, 'home_content', '{\"ainModuleBox\":1,\"yiyanBox\":1,\"sponsorBox\":0,\"siteBox\":1}');
COMMIT;

-- ----------------------------
-- Table structure for xf_navigation
-- ----------------------------
DROP TABLE IF EXISTS `xf_navigation`;
CREATE TABLE `xf_navigation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `icon` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL,
  `link` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pic` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of xf_navigation
-- ----------------------------
BEGIN;
INSERT INTO `xf_navigation` (`id`, `icon`, `link`, `pic`) VALUES (1, '/assets/images/qq_icon.png', 'tencent://message/?uin=1809185784&site=qq&Menu=yes', '');
INSERT INTO `xf_navigation` (`id`, `icon`, `link`, `pic`) VALUES (2, '/assets/images/wx.png', '', '/assets/upload/wx.jpg');
COMMIT;

-- ----------------------------
-- Table structure for xf_pay_config
-- ----------------------------
DROP TABLE IF EXISTS `xf_pay_config`;
CREATE TABLE `xf_pay_config` (
  `id` int NOT NULL AUTO_INCREMENT,
  `xf_key` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL,
  `xf_value` text COLLATE utf8mb4_unicode_ci,
  `xf_index` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of xf_pay_config
-- ----------------------------
BEGIN;
INSERT INTO `xf_pay_config` (`id`, `xf_key`, `xf_value`, `xf_index`) VALUES (1, 'channel', 'easyPay', 'config');
INSERT INTO `xf_pay_config` (`id`, `xf_key`, `xf_value`, `xf_index`) VALUES (2, 'easyPayUrl', NULL, 'easyPay');
INSERT INTO `xf_pay_config` (`id`, `xf_key`, `xf_value`, `xf_index`) VALUES (3, 'easyPayid', NULL, 'easyPay');
INSERT INTO `xf_pay_config` (`id`, `xf_key`, `xf_value`, `xf_index`) VALUES (4, 'easyPaykey', NULL, 'easyPay');
INSERT INTO `xf_pay_config` (`id`, `xf_key`, `xf_value`, `xf_index`) VALUES (5, 'appId', NULL, 'Alipay');
INSERT INTO `xf_pay_config` (`id`, `xf_key`, `xf_value`, `xf_index`) VALUES (6, 'privateKey', NULL, 'Alipay');
INSERT INTO `xf_pay_config` (`id`, `xf_key`, `xf_value`, `xf_index`) VALUES (7, 'alipayPublicKey', NULL, 'Alipay');
INSERT INTO `xf_pay_config` (`id`, `xf_key`, `xf_value`, `xf_index`) VALUES (8, 'gateway', 'https://openapi.alipay.com/gateway.do', 'Alipay');
INSERT INTO `xf_pay_config` (`id`, `xf_key`, `xf_value`, `xf_index`) VALUES (9, 'appAuthToken', NULL, 'Alipay');
INSERT INTO `xf_pay_config` (`id`, `xf_key`, `xf_value`, `xf_index`) VALUES (10, 'shoppingName', '拟态V5Pro赞助商品', 'config');
COMMIT;

-- ----------------------------
-- Table structure for xf_site_friends
-- ----------------------------
DROP TABLE IF EXISTS `xf_site_friends`;
CREATE TABLE `xf_site_friends` (
  `id` int NOT NULL AUTO_INCREMENT,
  `link` varchar(2048) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL,
  `introduced` varchar(2048) COLLATE utf8mb4_unicode_ci NOT NULL,
  `qq` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `img` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `isShow` int NOT NULL,
  `ip` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '127.0.0.1',
  `commitTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of xf_site_friends
-- ----------------------------
BEGIN;
INSERT INTO `xf_site_friends` (`id`, `link`, `name`, `introduced`, `qq`, `img`, `isShow`, `ip`, `commitTime`) VALUES (1, 'https://www.xfabe.com/', '小枫', '拟态5pro开发者', '1809185784', NULL, 1, 'admin_127.0.0.1_1745325871439', '2025-01-09 17:55:16');
INSERT INTO `xf_site_friends` (`id`, `link`, `name`, `introduced`, `qq`, `img`, `isShow`, `ip`, `commitTime`) VALUES (2, 'https://gumowl.com', '顾陌', '拟态5pro赞助商', '2102919229', NULL, 1, 'admin_::1_1736416560609', '2025-01-09 17:56:00');
INSERT INTO `xf_site_friends` (`id`, `link`, `name`, `introduced`, `qq`, `img`, `isShow`, `ip`, `commitTime`) VALUES (3, 'https://www.vpsf.net', '嘉维云', '拟态5pro服务器提供商', '511999671', NULL, 1, 'admin_::1_1736416603333', '2025-01-09 17:56:43');
INSERT INTO `xf_site_friends` (`id`, `link`, `name`, `introduced`, `qq`, `img`, `isShow`, `ip`, `commitTime`) VALUES (4, 'https://www.baidu.com', 'test', '测试一下', '123456', NULL, 0, '127.0.0.1', '2025-01-09 17:57:19');
COMMIT;

-- ----------------------------
-- Table structure for xf_sitemodule
-- ----------------------------
DROP TABLE IF EXISTS `xf_sitemodule`;
CREATE TABLE `xf_sitemodule` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL,
  `link` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL,
  `img` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of xf_sitemodule
-- ----------------------------
BEGIN;
INSERT INTO `xf_sitemodule` (`id`, `name`, `link`, `img`) VALUES (1, '小枫网络', 'https://www.xfabe.com', 'https://player.xfyun.club/img/blog_picture.jpg');
INSERT INTO `xf_sitemodule` (`id`, `name`, `link`, `img`) VALUES (2, '嘉惟云', 'https://www.vpsf.net', 'https://player.xfyun.club/img/jiawei.png');
INSERT INTO `xf_sitemodule` (`id`, `name`, `link`, `img`) VALUES (3, '顾陌网络', 'https://gumowl.com', NULL);
COMMIT;

-- ----------------------------
-- Table structure for xf_sponsors_list
-- ----------------------------
DROP TABLE IF EXISTS `xf_sponsors_list`;
CREATE TABLE `xf_sponsors_list` (
  `id` int NOT NULL AUTO_INCREMENT,
  `qq` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL,
  `orders` varchar(2048) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payStatus` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of xf_sponsors_list
-- ----------------------------
BEGIN;
INSERT INTO `xf_sponsors_list` (`id`, `qq`, `name`, `amount`, `orders`, `payStatus`) VALUES (1, '1809185784', '请赞助作者', '-100', '1744956317676', '0');
INSERT INTO `xf_sponsors_list` (`id`, `qq`, `name`, `amount`, `orders`, `payStatus`) VALUES (2, '511999671', '嘉维云mjb', '0.01', '1744956780026', '1');
INSERT INTO `xf_sponsors_list` (`id`, `qq`, `name`, `amount`, `orders`, `payStatus`) VALUES (3, '2707005951', 'xjb', '0.92', '1744969795676', '1');
COMMIT;

-- ----------------------------
-- Table structure for xf_users
-- ----------------------------
DROP TABLE IF EXISTS `xf_users`;
CREATE TABLE `xf_users` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(256) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户名',
  `password` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '密码',
  `qq` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'qq号',
  `email` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '邮箱',
  `status` int DEFAULT '1' COMMENT '用户状态',
  `authority` int DEFAULT '1' COMMENT '用户权限',
  `crete_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '登陆时间',
  `nickname` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT '用户' COMMENT '用户昵称',
  `avatar` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT 'https://q2.qlogo.cn/headimg_dl?dst_uin=123456&spec=100' COMMENT '头像',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `id_UNIQUE` (`id`) USING BTREE,
  UNIQUE KEY `username_UNIQUE` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of xf_users
-- ----------------------------
BEGIN;
INSERT INTO `xf_users` (`id`, `username`, `password`, `qq`, `email`, `status`, `authority`, `crete_time`, `nickname`, `avatar`) VALUES (1, 'admin', 'ff7f73b854845fc02aa13b777ac090fb1d9ebfe16c8950c7d26499371dd0b479', '1809185784', '1809185784@qq.com', 1, 10, '2025-04-22 20:40:42', '小枫', 'https://q2.qlogo.cn/headimg_dl?dst_uin=1809185784&spec=100');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;